Oracle数据库 sql高手请进来:取出某段时间段内,时间中天数连续的数据...答:直接用查询就可以得到你要的结果:select ID,NAME,VISIT_TIME from ( select ID,NAME,VISIT_TIME ,CNT ,max(CNT) over () MX from ( select ID,NAME,VISIT_TIME ,count(MINDATE) over (partition by MINDATE) CNT from ( select ID,NAME,VISIT_TIME ...
求一SQL语句,SQLServer和Oracle答:select a.name,a.maxcount as 最大count,a.date 最大count日期,b.mincount as 最小count,b.date as 最小count日期 from (select name , date ,max(count) as maxcount from tbName group by name,date) a left join (select name , date ,min(count) as mincount from tbName group...